package models;

import java.util.Date;
import java.util.Set;

import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.Lob;
import javax.persistence.ManyToMany;
import javax.persistence.ManyToOne;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import javax.persistence.Transient;

import play.db.jpa.Model;

@Entity
public class Book extends Model{
	
	//作者
	public String auts;
	
	//译者
	public String auty;
	
	//图书类别表ID 
	public String bookTypeIds;
	//出版社信息表ID 
	public String pressId;	
	//定价
	@Column(columnDefinition="double(8,2)")
	public Double price;
	//标签多个,号隔开
	@Column(name="boo_tag",length=3000)
	public String booTag;
	
	//图书等级
	@Column(name = "bookgrade")
	public int bookgrade;
	
	//书名 
	@Column(name="boo_name",length=100)
	public String booName; 
	//本书简介 
	@Column(name="boo_det")
	@Lob
	@Basic(fetch=FetchType.LAZY)
	public String booDet; 
	//	国际标准书号 
	@Column(name="boo_isbn",length=100)
	public String booIsbn; 
	//数量 
	@Column(name="boo_amou")
	public Integer booAmou; 
	//大图片路径 
	@Column(name="bimage",length=200)
	public String bimage; 
	//	小图片路径 
	@Column(name="simage",length=200)
	public String simage; 
	//	出版时间 
	@Column(name="boo_prti")
	@Temporal(TemporalType.DATE)
	public Date boo_prti; 
	//	上架时间 
	@Column(name="boo_puti")
	@Temporal(TemporalType.DATE)
	public Date booPuti; 
	//版次 
	@Column(name="boo_edit")
	public Integer booEdit; 
	//印次 
	@Column(name="boo_impr")
	public Integer booImpr;
	//印张
	@Column(name="boo_seal")
	public Integer booSeal;
	//印刷时间
	@Column(name="boo_printing_time")
	public Date booPrintingTime;
	//字数 
	@Column(name="boo_wonu")
	public Integer booWonu; 
	//装帧
	@Column(name="boo_zp")
	public Integer booZp; 
	//页数
	@Column(name="boo_pages")
	public Integer booPages;
	//条码
	@Column(name="boo_bar_code")
	public String booBarCode;
	//库位
	@Column(name="boo_storehouse")
	public String booStorehouse; 
	//	开数 
	@Column(name="boo_mo")
	public Integer booMo; 
	//	浏览量 
	@Column(name="boo_borw")
	public Integer booBrow; 
	//	借阅量 
	@Column(name="boo_borr")
	public Integer booBorr; 
	//  评论数
	@Column(name="boo_pin")
	public Integer booPin; 
	//	收藏量 
	@Column(name="boo_ensh")
	public Integer booEnsh; 
	//	推荐量 
	@Column(name="boo_reco")
	public Integer booReco; 
	//	作者相关简介 
	@Column(name="boo_wrde",length=4000)
	public String booWrde; 
	//排序 
	@Column(name="boo_order")
	public Integer booOrder;
	
	//捐书人
	public Long user;
	//等级
	public Integer level;
	
	//提纲
	@Column(name="boo_catalog")
	@Lob
	@Basic(fetch=FetchType.LAZY)
	public String booCatalog;

}
